<?php
/**
 * パスワード忘れ画面モデルクラス<br />
 *
 * @package apamanshop
 * @author K.Ikenaga
 * @copyright　
 */
class Mypage_Model_Paramlist extends Mypage_Model_Base
{
	/**
	 * アカウント情報の取得
	 *
	 * @param String $id ID
	 * @return エラーコード
	 */
	public function getCondList($id)
	{
		//DBパラメータ用配列生成
    	$db_params = array();

        //=====SQL生成=====
        $sql = '';
		$sql .= "SELECT";
		$sql .= "     T98_USER_CD";
		$sql .= "    ,T98_AREA_CD";
		$sql .= "    ,T98_TODOUFUKEN_CD";
		$sql .= "    ,T98_SHIKUCHOUSON_CD";
		$sql .= "    ,T98_CHOUMEI_CD";
		$sql .= "    ,T98_ENSEN_CD";
		$sql .= "    ,T98_EKI_CD";
		$sql .= "    ,T98_CHINRYO_MIN";
		$sql .= "    ,T98_CHINRYO_MAX";
		$sql .= "    ,T98_CHINRYO_JKN1";
		$sql .= "    ,T98_CHINRYO_JKN2";
		$sql .= "    ,T98_TATEMONO_CD";
		$sql .= "    ,T98_EKI_TOHO";
		$sql .= "    ,T98_SENYUU_MENSEKI_MIN";
		$sql .= "    ,T98_SENYUU_MENSEKI_MAX";
		$sql .= "    ,T98_MADORI";
		$sql .= "    ,T98_CHIKUNENN_KBN";
		$sql .= "    ,T98_KOUSHIN_KBN";
		$sql .= "    ,T98_SEARCH_TYPE";
		$sql .= "    ,T98_COMMUTING";
		$sql .= "    ,T98_KODAWARI_JYOKEN";
		$sql .= "    ,to_char(T98_TOUROKUBI,'YYYY/MM/DD HH24:MI:SS') T98_TOUROKUBI";
		$sql .= "    ,T98_MYPAGE_KBN";
		$sql .= "    ,T98_CAMPAIGN_FLAG";
		$sql .= "    ,T98_CHINRYO_JKN3";
		$sql .= "    ,T98_CHINRYO_JKN4";
		$sql .= "    ,T98_PARKING_KOMI_FLAG";
		$sql .= "    ,T98_MEYASU_CHINRYO_FLAG";
		$sql .= "    ,T98_SHIKIKIN_ZERO_FLAG";
		$sql .= "    ,T98_REIKIN_ZERO_FLAG";
		$sql .= "    ,T98_BUS_RIYOU_FLAG";
		$sql .= "    ,T98_SHOKI_HIYO_KBN";
		$sql .= "  FROM T98SEARCH_PARAM ";
		$sql .= " WHERE T98_USER_CD = :user_cd ";
		$sql .= " ORDER BY T98_TOUROKUBI Desc ";
		//=====データ取得=====

		$db_params['user_cd'] = $id;
		$condList = $this->dbGetList($sql, $db_params);

		return $condList;
	}

}
?>
